<%@ page import="java.sql.*" %>
<%
   String connectionURL = "jdbc:mysql://localhost/majjaw";
//?user=majjaw;password=ether272";
   Connection connection = null;
   Statement statement = null;
   ResultSet rs = null;

    Class.forName("com.mysql.jdbc.Driver").newInstance();
    connection = DriverManager.getConnection(connectionURL, "majjaw", "ether272");
    statement = connection.createStatement();
    rs = statement.executeQuery("SELECT * FROM mytesttb");

    while (rs.next()) {
       out.print("Sno: " + rs.getString("Sno") + ",  ");
       out.print(" Name: " + rs.getString("Name")+ ",  ");
       out.println(" Address: " + rs.getString("Address") +"<br>");
    }

    rs.close();
%>
